Enhanced Excel export error

Hi,

 

I was trying to use the enhanced Excel export tool and it worked fine for me until i updated excel to 2013.

Now i get merged data on top of each other and the export is out of sync.

Is there any solution for this.Did any of you face the same issue?

Note:I found this script in Galactic solution website.


Gsquare - Wed Sep 21 04:42:30 EDT 2016

Re: Enhanced Excel export error
PekkaMakinen - Fri Sep 23 02:23:51 EDT 2016

Had similar problems when we moved to Office 2013. The handling of OLE objects seems to be changed, I solved the export problems by not exporting OLE. Also the freeze rows / split display options sometimes ran into problems. Try to edit the options in Enchanced Excel Export dialog.

Re: Enhanced Excel export error
Chris Annal - Thu Dec 08 08:44:45 EST 2016

What Pekka said is good advice. You might also try creating an Excel template first (xltx), then on the "Template" tab of the Enhanced Export, select "Existing template" and export to the one you created. That might help you avoid the problems.

Re: Enhanced Excel export error
Gsquare - Fri Dec 09 03:05:42 EST 2016

Thanks for the inputs.

I shall try both the solutions and get back.

Re: Enhanced Excel export error
Gsquare - Fri Dec 09 03:46:12 EST 2016

PekkaMakinen - Fri Sep 23 02:23:51 EDT 2016

Had similar problems when we moved to Office 2013. The handling of OLE objects seems to be changed, I solved the export problems by not exporting OLE. Also the freeze rows / split display options sometimes ran into problems. Try to edit the options in Enchanced Excel Export dialog.

Setting the split header toggle to false, did the trick!!!

Thanks for the help.